﻿CREATE TABLE [accounting].[AccountsStructure] (
    [AccountID]     INT            NOT NULL,
    [AccountNumber] NVARCHAR (50)  NOT NULL,
    [AccountName]   NVARCHAR (100) NOT NULL,
    [Description]   NVARCHAR (100) NULL,
    [Details]       NVARCHAR (100) NULL,
    [Text]          NVARCHAR (100) NULL,
    [Ef]            BIT            CONSTRAINT [DF_AccountsStructure_Ef] DEFAULT ((0)) NOT NULL,
    [Og]            BIT            CONSTRAINT [DF_AccountsStructure_Og] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK__Accounts__349DA5861E3A7A34] PRIMARY KEY CLUSTERED ([AccountID] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_accounting_AccountsStructure_AccountNumber]
    ON [accounting].[AccountsStructure]([AccountID] ASC, [AccountNumber] ASC);

